{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Entries","Lists"],"not_rendered":{"images":2,"macros":1,"external_links":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Entries","index":0,"n_rows":17,"n_cols":13,"rows_kept":17}
[]
[null,"Select a Category",{"$nulls":4},"Select a Product"]
[]
[{"$nulls":11}," -","Product Combo is 2 columns, "]
[{"$nulls":11}," -","First column has product code, second column has product name"]
[{"$nulls":11}," -","First column is set to zero width"]
[{"$nulls":11}," -","Combo is linked to cell H9"]
[]
[{"$nulls":6},"Code","CK01"]
[{"$nulls":6},"Price",{"$f":"IFERROR(INDEX(tblProducts[Cost],MATCH(H9,tblProducts[Code],0)),\"\")","v":2.1799999999999997},null," -","INDEX/MATCH formula finds price for "]
[{"$nulls":10},"selected product based on the code"]
[]
[]
[{"$nulls":11}," -","When Category combo is changed, "]
[{"$nulls":12},"it clears out the Product combo"]
[{"$nulls":12},"and creates a drop down list of products"]
[{"$nulls":12},"for the selected category"]

{"sheet":"Lists","index":1,"n_rows":11,"n_cols":8,"rows_kept":11}
[null,"Category","Product","Code","Cost",null,null,"Category"]
[null,"Bars","Banana","BR01",2.27,null,null,"Bars"]
[null,"Bars","Bran","BR02",1.8699999999999999,null,null,"Cookies"]
[null,"Bars","Carrot","BR03",1.7699999999999998,null,null,"Crackers"]
[null,"Cookies","Arrowroot","CK01",2.1799999999999997,null,null,"Snacks"]
[null,"Cookies","Chocolate Chip","CK02",1.8699999999999999]
[null,"Cookies","Oatmeal Raisin","CK03",2.84]
[null,"Crackers","Saltines","CR01",2.19]
[null,"Crackers","Whole Wheat","CR02",2.79]
[null,"Snacks","Potato Chips","SN01",1.68]
[null,"Snacks","Pretzels","SN02",3.15]